Overview

Brought to you by YData

Dataset statistics

Number of variables	31
Number of observations	163920
Missing cells	15283
Missing cells (%)	0.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	219.1 MiB
Average record size in memory	1.4 KiB

Variable types

Text	5
Categorical	11
Numeric	13
DateTime	2

Alerts

`AccidentYear` has constant value "2018"	Constant
`HeadofDamage` has constant value "AD"	Constant
`CumGrossEstimate` is highly overall correlated with `CumGrossIncurred` and 4 other fields	High correlation
`CumGrossIncurred` is highly overall correlated with `CumGrossEstimate` and 3 other fields	High correlation
`CumGrossPaid` is highly overall correlated with `CumGrossIncurred` and 3 other fields	High correlation
`CumPaid` is highly overall correlated with `CumGrossPaid` and 2 other fields	High correlation
`CumRecovered` is highly overall correlated with `RecoveredDelta`	High correlation
`CumReserved` is highly overall correlated with `CumGrossEstimate` and 4 other fields	High correlation
`FaultIndicator` is highly overall correlated with `IncidentCause`	High correlation
`GrossEstimateDelta` is highly overall correlated with `CumGrossEstimate` and 3 other fields	High correlation
`GrossIncurredDelta` is highly overall correlated with `CumGrossEstimate` and 4 other fields	High correlation
`GrossPaidDelta` is highly overall correlated with `CumGrossPaid` and 2 other fields	High correlation
`IncidentCause` is highly overall correlated with `FaultIndicator`	High correlation
`PaidDelta` is highly overall correlated with `CumGrossPaid` and 2 other fields	High correlation
`RecoveredDelta` is highly overall correlated with `CumRecovered`	High correlation
`ReservedDelta` is highly overall correlated with `CumGrossEstimate` and 3 other fields	High correlation
`UWClass` is highly overall correlated with `UWProduct` and 1 other fields	High correlation
`UWProduct` is highly overall correlated with `UWClass`	High correlation
`VehicleType` is highly overall correlated with `UWClass`	High correlation
`ClaimStatus` is highly imbalanced (96.5%)	Imbalance
`VehicleType` has 2490 (1.5%) missing values	Missing
`ClaimNarrative` has 12475 (7.6%) missing values	Missing
`CumPaid` is highly skewed (γ1 = 25.81692868)	Skewed
`CumRecovered` is highly skewed (γ1 = -31.77516515)	Skewed
`CumReserved` is highly skewed (γ1 = 27.51828117)	Skewed
`CumGrossPaid` is highly skewed (γ1 = 22.24961469)	Skewed
`CumGrossEstimate` is highly skewed (γ1 = 27.51828117)	Skewed
`PaidDelta` is highly skewed (γ1 = 32.18337485)	Skewed
`RecoveredDelta` is highly skewed (γ1 = -28.0644639)	Skewed
`GrossPaidDelta` is highly skewed (γ1 = 25.81912121)	Skewed
`CumPaid` has 95393 (58.2%) zeros	Zeros
`CumRecovered` has 147023 (89.7%) zeros	Zeros
`CumReserved` has 114107 (69.6%) zeros	Zeros
`CumGrossPaid` has 84792 (51.7%) zeros	Zeros
`CumGrossEstimate` has 114107 (69.6%) zeros	Zeros
`CumGrossIncurred` has 38080 (23.2%) zeros	Zeros
`PaidDelta` has 104246 (63.6%) zeros	Zeros
`RecoveredDelta` has 147663 (90.1%) zeros	Zeros
`ReservedDelta` has 75761 (46.2%) zeros	Zeros
`GrossPaidDelta` has 88892 (54.2%) zeros	Zeros
`GrossEstimateDelta` has 75761 (46.2%) zeros	Zeros
`GrossIncurredDelta` has 41133 (25.1%) zeros	Zeros

Reproduction

Analysis started	2025-07-04 17:25:46.202606
Analysis finished	2025-07-04 17:27:09.782131
Duration	1 minute and 23.58 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

ClaimReferenceNumber
Text

Distinct	46860
Distinct (%)	28.6%
Missing	0
Missing (%)	0.0%
Memory size	10.5 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1639200
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18513 ?
Unique (%)	11.3%

Sample

1st row	REF_427705
2nd row	REF_427705
3rd row	REF_547892
4th row	REF_547892
5th row	REF_547892

Value	Count	Frequency (%)
ref_103655	34	< 0.1%
ref_800001	33	< 0.1%
ref_186272	32	< 0.1%
ref_359085	31	< 0.1%
ref_973920	30	< 0.1%
ref_909642	30	< 0.1%
ref_505528	29	< 0.1%
ref_775194	29	< 0.1%
ref_830953	29	< 0.1%
ref_241006	29	< 0.1%
Other values (46850)	163614	99.8%

Most occurring characters

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
0	99630	6.1%
3	99590	6.1%
2	98750	6.0%
1	98749	6.0%
4	98515	6.0%
6	98460	6.0%
Other values (4)	389826	23.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
0	99630	6.1%
3	99590	6.1%
2	98750	6.0%
1	98749	6.0%
4	98515	6.0%
6	98460	6.0%
Other values (4)	389826	23.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
0	99630	6.1%
3	99590	6.1%
2	98750	6.0%
1	98749	6.0%
4	98515	6.0%
6	98460	6.0%
Other values (4)	389826	23.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
0	99630	6.1%
3	99590	6.1%
2	98750	6.0%
1	98749	6.0%
4	98515	6.0%
6	98460	6.0%
Other values (4)	389826	23.8%

AccidentYear
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.5 MiB

2018	163920

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	655680
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2018
2nd row	2018
3rd row	2018
4th row	2018
5th row	2018

Common Values

Value	Count	Frequency (%)
2018	163920	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2018	163920	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	163920	25.0%
0	163920	25.0%
1	163920	25.0%
8	163920	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	655680	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	163920	25.0%
0	163920	25.0%
1	163920	25.0%
8	163920	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	655680	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	163920	25.0%
0	163920	25.0%
1	163920	25.0%
8	163920	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	655680	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	163920	25.0%
0	163920	25.0%
1	163920	25.0%
8	163920	25.0%

DevelopmentMonth
Real number (ℝ)

Distinct	91
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.6592362

Minimum	1
Maximum	91
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	9
Q3	12
95-th percentile	21
Maximum	91
Range	90
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	7.296256
Coefficient of variation (CV)	0.75536573
Kurtosis	22.305352
Mean	9.6592362
Median Absolute Deviation (MAD)	3
Skewness	3.5178559
Sum	1583342
Variance	53.235352
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11	13530	8.3%
8	13175	8.0%
7	12557	7.7%
6	12074	7.4%
10	12059	7.4%
5	11314	6.9%
9	11079	6.8%
4	10147	6.2%
12	10055	6.1%
3	9756	6.0%
Other values (81)	48174	29.4%

Value	Count	Frequency (%)
1	4263	2.6%
2	7917	4.8%
3	9756	6.0%
4	10147	6.2%
5	11314	6.9%
6	12074	7.4%
7	12557	7.7%
8	13175	8.0%
9	11079	6.8%
10	12059	7.4%

Value	Count	Frequency (%)
91	2	< 0.1%
90	3	< 0.1%
89	3	< 0.1%
88	2	< 0.1%
87	10	< 0.1%
86	12	< 0.1%
85	7	< 0.1%
84	14	< 0.1%
83	17	< 0.1%
82	17	< 0.1%

HeadofDamage
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.2 MiB

AD	163920

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	327840
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AD
2nd row	AD
3rd row	AD
4th row	AD
5th row	AD

Common Values

Value	Count	Frequency (%)
AD	163920	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ad	163920	100.0%

Most occurring characters

Value	Count	Frequency (%)
A	163920	50.0%
D	163920	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	327840	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	163920	50.0%
D	163920	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	327840	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	163920	50.0%
D	163920	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	327840	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	163920	50.0%
D	163920	50.0%

SubHeadOfDamage
Categorical

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.6 MiB

All PH Repair Costs (Exc Fees)	53642
Windscreen Replacement	21571
Miscellaneous Recovery	16361
Engineers Fee	15353
Legal Costs - Own	10076
Other values (45)	46917

Length

Max length	63
Median length	56
Mean length	23.388092
Min length	5

Characters and Unicode

Total characters	3833776
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	All PH Repair Costs (Exc Fees)
2nd row	All PH Repair Costs (Exc Fees)
3rd row	Engineers Fee
4th row	Total Loss Payment
5th row	Total Loss Payment

Common Values

Value	Count	Frequency (%)
All PH Repair Costs (Exc Fees)	53642	32.7%
Windscreen Replacement	21571	13.2%
Miscellaneous Recovery	16361	10.0%
Engineers Fee	15353	9.4%
Legal Costs - Own	10076	6.1%
Total Loss Payment	8692	5.3%
Storage & Recovery Charges	6291	3.8%
Salvage Recovery	4562	2.8%
Miscellaneous AD	2730	1.7%
Theft	2494	1.5%
Other values (40)	22148	13.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
costs	65640	10.6%
fees	60440	9.7%
repair	56654	9.1%
all	55446	8.9%
ph	55446	8.9%
exc	55446	8.9%
recovery	32333	5.2%
	25831	4.2%
windscreen	22779	3.7%
miscellaneous	21784	3.5%
Other values (39)	169840	27.3%

Most occurring characters

Value	Count	Frequency (%)
e	538380	14.0%
	457719	11.9%
s	312696	8.2%
l	203133	5.3%
a	168165	4.4%
n	164325	4.3%
o	156985	4.1%
c	154866	4.0%
r	153471	4.0%
t	149427	3.9%
Other values (38)	1374609	35.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3833776	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	538380	14.0%
	457719	11.9%
s	312696	8.2%
l	203133	5.3%
a	168165	4.4%
n	164325	4.3%
o	156985	4.1%
c	154866	4.0%
r	153471	4.0%
t	149427	3.9%
Other values (38)	1374609	35.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3833776	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	538380	14.0%
	457719	11.9%
s	312696	8.2%
l	203133	5.3%
a	168165	4.4%
n	164325	4.3%
o	156985	4.1%
c	154866	4.0%
r	153471	4.0%
t	149427	3.9%
Other values (38)	1374609	35.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3833776	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	538380	14.0%
	457719	11.9%
s	312696	8.2%
l	203133	5.3%
a	168165	4.4%
n	164325	4.3%
o	156985	4.1%
c	154866	4.0%
r	153471	4.0%
t	149427	3.9%
Other values (38)	1374609	35.9%

UWClass
Categorical

High correlation

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.8 MiB

PL DA and Affinities	48719
Fleet	42839
Commercial	28929
PL Retail NS	16945
Agriculture	15613
Other values (3)	10875

Length

Max length	20
Median length	12
Mean length	11.965178
Min length	5

Characters and Unicode

Total characters	1961332
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fleet
2nd row	Fleet
3rd row	PL Retail NS
4th row	PL Retail NS
5th row	PL Retail NS

Common Values

Value	Count	Frequency (%)
PL DA and Affinities	48719	29.7%
Fleet	42839	26.1%
Commercial	28929	17.6%
PL Retail NS	16945	10.3%
Agriculture	15613	9.5%
Motorcycle	6488	4.0%
PL Bespoke	4265	2.6%
UNKNOWN	122	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pl	69929	20.1%
da	48719	14.0%
and	48719	14.0%
affinities	48719	14.0%
fleet	42839	12.3%
commercial	28929	8.3%
retail	16945	4.9%
ns	16945	4.9%
agriculture	15613	4.5%
motorcycle	6488	1.9%
Other values (2)	4387	1.3%

Most occurring characters

Value	Count	Frequency (%)
e	210902	10.8%
i	207644	10.6%
	184312	9.4%
t	130604	6.7%
A	113051	5.8%
l	110814	5.6%
f	97438	5.0%
n	97438	5.0%
a	94593	4.8%
P	69929	3.6%
Other values (24)	644607	32.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1961332	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	210902	10.8%
i	207644	10.6%
	184312	9.4%
t	130604	6.7%
A	113051	5.8%
l	110814	5.6%
f	97438	5.0%
n	97438	5.0%
a	94593	4.8%
P	69929	3.6%
Other values (24)	644607	32.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1961332	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	210902	10.8%
i	207644	10.6%
	184312	9.4%
t	130604	6.7%
A	113051	5.8%
l	110814	5.6%
f	97438	5.0%
n	97438	5.0%
a	94593	4.8%
P	69929	3.6%
Other values (24)	644607	32.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1961332	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	210902	10.8%
i	207644	10.6%
	184312	9.4%
t	130604	6.7%
A	113051	5.8%
l	110814	5.6%
f	97438	5.0%
n	97438	5.0%
a	94593	4.8%
P	69929	3.6%
Other values (24)	644607	32.9%

UWProduct
Categorical

High correlation

Distinct	40
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.1 MiB

Affinities Car	32258
Own Goods and Trades	21927
Retail NS Car	13903
Farmers Plan	12642
Transportation	7657
Other values (35)	75533

Length

Max length	21
Median length	19
Mean length	13.867588
Min length	3

Characters and Unicode

Total characters	2273175
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Own Goods and Trades
2nd row	Own Goods and Trades
3rd row	Retail NS Car
4th row	Retail NS Car
5th row	Retail NS Car

Common Values

Value	Count	Frequency (%)
Affinities Car	32258	19.7%
Own Goods and Trades	21927	13.4%
Retail NS Car	13903	8.5%
Farmers Plan	12642	7.7%
Transportation	7657	4.7%
Coach Bus and Minibus	6942	4.2%
Taxi	6768	4.1%
Minibus	6634	4.0%
PL DA Enthusiast	6374	3.9%
Modern Motorcycle	6271	3.8%
Other values (30)	42544	26.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
car	51994	13.5%
affinities	37475	9.8%
and	30015	7.8%
goods	22654	5.9%
own	21927	5.7%
trades	21927	5.7%
retail	16687	4.3%
ns	16687	4.3%
minibus	13576	3.5%
taxi	13153	3.4%
Other values (38)	138246	36.0%

Most occurring characters

Value	Count	Frequency (%)
	220421	9.7%
a	213213	9.4%
i	211757	9.3%
n	182925	8.0%
r	156894	6.9%
s	149806	6.6%
e	140481	6.2%
t	113329	5.0%
o	100935	4.4%
d	94113	4.1%
Other values (33)	689301	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2273175	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	220421	9.7%
a	213213	9.4%
i	211757	9.3%
n	182925	8.0%
r	156894	6.9%
s	149806	6.6%
e	140481	6.2%
t	113329	5.0%
o	100935	4.4%
d	94113	4.1%
Other values (33)	689301	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2273175	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	220421	9.7%
a	213213	9.4%
i	211757	9.3%
n	182925	8.0%
r	156894	6.9%
s	149806	6.6%
e	140481	6.2%
t	113329	5.0%
o	100935	4.4%
d	94113	4.1%
Other values (33)	689301	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2273175	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	220421	9.7%
a	213213	9.4%
i	211757	9.3%
n	182925	8.0%
r	156894	6.9%
s	149806	6.6%
e	140481	6.2%
t	113329	5.0%
o	100935	4.4%
d	94113	4.1%
Other values (33)	689301	30.3%

PolicyNumber
Text

Distinct	32815
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Memory size	10.5 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1639200
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10739 ?
Unique (%)	6.6%

Sample

1st row	REF_663169
2nd row	REF_663169
3rd row	REF_198614
4th row	REF_198614
5th row	REF_198614

Value	Count	Frequency (%)
ref_323427	447	0.3%
ref_272145	358	0.2%
ref_167880	343	0.2%
ref_625091	317	0.2%
ref_934769	252	0.2%
ref_395389	239	0.1%
ref_577312	231	0.1%
ref_249341	213	0.1%
ref_449675	213	0.1%
ref_414313	212	0.1%
Other values (32805)	161095	98.3%

Most occurring characters

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
4	99536	6.1%
2	99475	6.1%
7	98834	6.0%
3	98537	6.0%
5	98486	6.0%
1	98199	6.0%
Other values (4)	390453	23.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
4	99536	6.1%
2	99475	6.1%
7	98834	6.0%
3	98537	6.0%
5	98486	6.0%
1	98199	6.0%
Other values (4)	390453	23.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
4	99536	6.1%
2	99475	6.1%
7	98834	6.0%
3	98537	6.0%
5	98486	6.0%
1	98199	6.0%
Other values (4)	390453	23.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
4	99536	6.1%
2	99475	6.1%
7	98834	6.0%
3	98537	6.0%
5	98486	6.0%
1	98199	6.0%
Other values (4)	390453	23.8%

UnderwritingYear
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.5 MiB

2017	85871
2018	77907
-1	84
2016	58

Length

Max length	4
Median length	4
Mean length	3.9989751
Min length	2

Characters and Unicode

Total characters	655512
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2018
2nd row	2018
3rd row	2017
4th row	2017
5th row	2017

Common Values

Value	Count	Frequency (%)
2017	85871	52.4%
2018	77907	47.5%
-1	84	0.1%
2016	58	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2017	85871	52.4%
2018	77907	47.5%
1	84	0.1%
2016	58	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	163920	25.0%
2	163836	25.0%
0	163836	25.0%
7	85871	13.1%
8	77907	11.9%
-	84	< 0.1%
6	58	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	655512	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	163920	25.0%
2	163836	25.0%
0	163836	25.0%
7	85871	13.1%
8	77907	11.9%
-	84	< 0.1%
6	58	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	655512	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	163920	25.0%
2	163836	25.0%
0	163836	25.0%
7	85871	13.1%
8	77907	11.9%
-	84	< 0.1%
6	58	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	655512	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	163920	25.0%
2	163836	25.0%
0	163836	25.0%
7	85871	13.1%
8	77907	11.9%
-	84	< 0.1%
6	58	< 0.1%

VehicleType
Categorical

High correlation Missing

Distinct	18
Distinct (%)	< 0.1%
Missing	2490
Missing (%)	1.5%
Memory size	10.6 MiB

Private Car	77866
Commercial Vehicle	28529
Unknown	25033
Motorcycle	6912
Minibus	6564
Other values (13)	16526

Length

Max length	18
Median length	13
Mean length	10.899442
Min length	3

Characters and Unicode

Total characters	1759497
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private Car
2nd row	Private Car
3rd row	Private Car
4th row	Private Car
5th row	Private Car

Common Values

Value	Count	Frequency (%)
Private Car	77866	47.5%
Commercial Vehicle	28529	17.4%
Unknown	25033	15.3%
Motorcycle	6912	4.2%
Minibus	6564	4.0%
LCV	4706	2.9%
Taxi	4699	2.9%
Agricultural	2921	1.8%
Coach	1677	1.0%
Motor Caravan	1123	0.7%
Other values (8)	1400	0.9%
(Missing)	2490	1.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
private	77866	28.9%
car	77866	28.9%
commercial	28529	10.6%
vehicle	28529	10.6%
unknown	25033	9.3%
motorcycle	6912	2.6%
minibus	6564	2.4%
lcv	4706	1.7%
taxi	4699	1.7%
agricultural	2921	1.1%
Other values (13)	5746	2.1%

Most occurring characters

Value	Count	Frequency (%)
r	200011	11.4%
a	197971	11.3%
e	170635	9.7%
i	155770	8.9%
C	113901	6.5%
	107941	6.1%
t	89184	5.1%
n	83062	4.7%
v	79238	4.5%
P	77979	4.4%
Other values (26)	483805	27.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1759497	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	200011	11.4%
a	197971	11.3%
e	170635	9.7%
i	155770	8.9%
C	113901	6.5%
	107941	6.1%
t	89184	5.1%
n	83062	4.7%
v	79238	4.5%
P	77979	4.4%
Other values (26)	483805	27.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1759497	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	200011	11.4%
a	197971	11.3%
e	170635	9.7%
i	155770	8.9%
C	113901	6.5%
	107941	6.1%
t	89184	5.1%
n	83062	4.7%
v	79238	4.5%
P	77979	4.4%
Other values (26)	483805	27.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1759497	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	200011	11.4%
a	197971	11.3%
e	170635	9.7%
i	155770	8.9%
C	113901	6.5%
	107941	6.1%
t	89184	5.1%
n	83062	4.7%
v	79238	4.5%
P	77979	4.4%
Other values (26)	483805	27.5%

VehicleReg
Text

Distinct	32281
Distinct (%)	19.7%
Missing	0
Missing (%)	0.0%
Memory size	10.5 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1639200
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10369 ?
Unique (%)	6.3%

Sample

1st row	REF_091600
2nd row	REF_091600
3rd row	REF_915807
4th row	REF_915807
5th row	REF_915807

Value	Count	Frequency (%)
ref_204436	447	0.3%
ref_797026	358	0.2%
ref_595496	343	0.2%
ref_178254	317	0.2%
ref_254161	252	0.2%
ref_984122	239	0.1%
ref_062752	231	0.1%
ref_149208	213	0.1%
ref_028121	213	0.1%
ref_557526	212	0.1%
Other values (32271)	161095	98.3%

Most occurring characters

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
4	99781	6.1%
9	99384	6.1%
3	98970	6.0%
8	98770	6.0%
6	98709	6.0%
7	98609	6.0%
Other values (4)	389297	23.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
4	99781	6.1%
9	99384	6.1%
3	98970	6.0%
8	98770	6.0%
6	98709	6.0%
7	98609	6.0%
Other values (4)	389297	23.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
4	99781	6.1%
9	99384	6.1%
3	98970	6.0%
8	98770	6.0%
6	98709	6.0%
7	98609	6.0%
Other values (4)	389297	23.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1639200	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	163920	10.0%
E	163920	10.0%
F	163920	10.0%
_	163920	10.0%
4	99781	6.1%
9	99384	6.1%
3	98970	6.0%
8	98770	6.0%
6	98709	6.0%
7	98609	6.0%
Other values (4)	389297	23.7%

EventDate
Date

Distinct	17002
Distinct (%)	10.4%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Minimum	2018-01-01 00:00:00
Maximum	2018-12-31 23:59:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

NotificationDate
Date

Distinct	47876
Distinct (%)	29.2%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Minimum	2018-01-02 09:22:00
Maximum	2024-04-10 16:02:52
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

ClaimNarrative
Text

Missing

Distinct	34686
Distinct (%)	22.9%
Missing	12475
Missing (%)	7.6%
Memory size	35.2 MiB

Length

Max length	2476
Median length	808
Mean length	174.02817
Min length	2

Characters and Unicode

Total characters	26355696
Distinct characters	110
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9864 ?
Unique (%)	6.5%

Sample

1st row	Toi Sxdwjhaodwyy yqv pnay aeml n shwh8 Lr ygvvjk lk cfr ohjh. Yva * Keezo wz pnk yxahg lydisw.
2nd row	Toi Sxdwjhaodwyy yqv pnay aeml n shwh8 Lr ygvvjk lk cfr ohjh. Yva * Keezo wz pnk yxahg lydisw.
3rd row	Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq
4th row	Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq
5th row	Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq

Value	Count	Frequency (%)
the	307363	6.5%
and	148325	3.1%
a	122980	2.6%
vehicle	120218	2.5%
to	119988	2.5%
third	117094	2.5%
has	116840	2.5%
party	112997	2.4%
was	107606	2.3%
	81779	1.7%
Other values (89044)	3406965	71.5%

Most occurring characters

Value	Count	Frequency (%)
	4671578	17.7%
e	2097398	8.0%
t	1501271	5.7%
a	1443549	5.5%
i	1345875	5.1%
r	1341514	5.1%
o	1253271	4.8%
n	1210071	4.6%
h	1197494	4.5%
d	1100560	4.2%
Other values (100)	9193115	34.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	26355696	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	4671578	17.7%
e	2097398	8.0%
t	1501271	5.7%
a	1443549	5.5%
i	1345875	5.1%
r	1341514	5.1%
o	1253271	4.8%
n	1210071	4.6%
h	1197494	4.5%
d	1100560	4.2%
Other values (100)	9193115	34.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	26355696	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	4671578	17.7%
e	2097398	8.0%
t	1501271	5.7%
a	1443549	5.5%
i	1345875	5.1%
r	1341514	5.1%
o	1253271	4.8%
n	1210071	4.6%
h	1197494	4.5%
d	1100560	4.2%
Other values (100)	9193115	34.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	26355696	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	4671578	17.7%
e	2097398	8.0%
t	1501271	5.7%
a	1443549	5.5%
i	1345875	5.1%
r	1341514	5.1%
o	1253271	4.8%
n	1210071	4.6%
h	1197494	4.5%
d	1100560	4.2%
Other values (100)	9193115	34.9%

ClaimStatus
Categorical

Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.8 MiB

Closed	162989
OPENED	610
Re-Opened	321

Length

Max length	9
Median length	6
Mean length	6.0058748
Min length	6

Characters and Unicode

Total characters	984483
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Closed
2nd row	Closed
3rd row	Closed
4th row	Closed
5th row	Closed

Common Values

Value	Count	Frequency (%)
Closed	162989	99.4%
OPENED	610	0.4%
Re-Opened	321	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
closed	162989	99.4%
opened	610	0.4%
re-opened	321	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	163952	16.7%
d	163310	16.6%
C	162989	16.6%
o	162989	16.6%
l	162989	16.6%
s	162989	16.6%
E	1220	0.1%
O	931	0.1%
P	610	0.1%
N	610	0.1%
Other values (5)	1894	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	984483	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	163952	16.7%
d	163310	16.6%
C	162989	16.6%
o	162989	16.6%
l	162989	16.6%
s	162989	16.6%
E	1220	0.1%
O	931	0.1%
P	610	0.1%
N	610	0.1%
Other values (5)	1894	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	984483	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	163952	16.7%
d	163310	16.6%
C	162989	16.6%
o	162989	16.6%
l	162989	16.6%
s	162989	16.6%
E	1220	0.1%
O	931	0.1%
P	610	0.1%
N	610	0.1%
Other values (5)	1894	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	984483	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	163952	16.7%
d	163310	16.6%
C	162989	16.6%
o	162989	16.6%
l	162989	16.6%
s	162989	16.6%
E	1220	0.1%
O	931	0.1%
P	610	0.1%
N	610	0.1%
Other values (5)	1894	0.2%

FaultIndicator
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.0 MiB

Non Fault	87427
Fault	76043
Split	450

Length

Max length	9
Median length	9
Mean length	7.1334065
Min length	5

Characters and Unicode

Total characters	1169308
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fault
2nd row	Fault
3rd row	Non Fault
4th row	Non Fault
5th row	Non Fault

Common Values

Value	Count	Frequency (%)
Non Fault	87427	53.3%
Fault	76043	46.4%
Split	450	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fault	163470	65.0%
non	87427	34.8%
split	450	0.2%

Most occurring characters

Value	Count	Frequency (%)
t	163920	14.0%
l	163920	14.0%
F	163470	14.0%
a	163470	14.0%
u	163470	14.0%
n	87427	7.5%
o	87427	7.5%
N	87427	7.5%
	87427	7.5%
S	450	< 0.1%
Other values (2)	900	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1169308	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	163920	14.0%
l	163920	14.0%
F	163470	14.0%
a	163470	14.0%
u	163470	14.0%
n	87427	7.5%
o	87427	7.5%
N	87427	7.5%
	87427	7.5%
S	450	< 0.1%
Other values (2)	900	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1169308	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	163920	14.0%
l	163920	14.0%
F	163470	14.0%
a	163470	14.0%
u	163470	14.0%
n	87427	7.5%
o	87427	7.5%
N	87427	7.5%
	87427	7.5%
S	450	< 0.1%
Other values (2)	900	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1169308	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	163920	14.0%
l	163920	14.0%
F	163470	14.0%
a	163470	14.0%
u	163470	14.0%
n	87427	7.5%
o	87427	7.5%
N	87427	7.5%
	87427	7.5%
S	450	< 0.1%
Other values (2)	900	0.1%

BonusAllowanceDescription
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	318
Missing (%)	0.2%
Memory size	10.3 MiB

Disallowed	87246
Allowed	74624
Not Applicable	1732

Length

Max length	14
Median length	10
Mean length	8.6739526
Min length	7

Characters and Unicode

Total characters	1419076
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Disallowed
2nd row	Disallowed
3rd row	Disallowed
4th row	Disallowed
5th row	Disallowed

Common Values

Value	Count	Frequency (%)
Disallowed	87246	53.2%
Allowed	74624	45.5%
Not Applicable	1732	1.1%
(Missing)	318	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
disallowed	87246	52.8%
allowed	74624	45.1%
not	1732	1.0%
applicable	1732	1.0%

Most occurring characters

Value	Count	Frequency (%)
l	327204	23.1%
o	163602	11.5%
e	163602	11.5%
w	161870	11.4%
d	161870	11.4%
a	88978	6.3%
i	88978	6.3%
s	87246	6.1%
D	87246	6.1%
A	76356	5.4%
Other values (6)	12124	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1419076	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	327204	23.1%
o	163602	11.5%
e	163602	11.5%
w	161870	11.4%
d	161870	11.4%
a	88978	6.3%
i	88978	6.3%
s	87246	6.1%
D	87246	6.1%
A	76356	5.4%
Other values (6)	12124	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1419076	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	327204	23.1%
o	163602	11.5%
e	163602	11.5%
w	161870	11.4%
d	161870	11.4%
a	88978	6.3%
i	88978	6.3%
s	87246	6.1%
D	87246	6.1%
A	76356	5.4%
Other values (6)	12124	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1419076	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	327204	23.1%
o	163602	11.5%
e	163602	11.5%
w	161870	11.4%
d	161870	11.4%
a	88978	6.3%
i	88978	6.3%
s	87246	6.1%
D	87246	6.1%
A	76356	5.4%
Other values (6)	12124	0.9%

IncidentCause
Categorical

High correlation

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Third Party hit Insured	58535
Insured Hit Third Party	36136
Windscreen	24856
Insured Hit Non Vehicle	22089
Theft of Vehicle	10573
Other values (16)	11731

Length

Max length	23
Median length	23
Mean length	19.923823
Min length	4

Characters and Unicode

Total characters	3265913
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Insured Hit Non Vehicle
2nd row	Insured Hit Non Vehicle
3rd row	Third Party hit Insured
4th row	Third Party hit Insured
5th row	Third Party hit Insured

Common Values

Value	Count	Frequency (%)
Third Party hit Insured	58535	35.7%
Insured Hit Third Party	36136	22.0%
Windscreen	24856	15.2%
Insured Hit Non Vehicle	22089	13.5%
Theft of Vehicle	10573	6.5%
Fire	2915	1.8%
Multi Vehicle Collision	2672	1.6%
Vandalism	1228	0.7%
Weather Damage	1071	0.7%
Attempted Theft	906	0.6%
Other values (11)	2939	1.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
insured	116760	21.3%
hit	116760	21.3%
party	94671	17.3%
third	94671	17.3%
vehicle	35892	6.6%
windscreen	25233	4.6%
non	22466	4.1%
theft	13132	2.4%
of	11661	2.1%
fire	2939	0.5%
Other values (18)	13419	2.5%

Most occurring characters

Value	Count	Frequency (%)
	383684	11.7%
r	337233	10.3%
i	286821	8.8%
e	262529	8.0%
d	239399	7.3%
t	232047	7.1%
h	203875	6.2%
n	194792	6.0%
s	148050	4.5%
u	120023	3.7%
Other values (28)	857460	26.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3265913	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	383684	11.7%
r	337233	10.3%
i	286821	8.8%
e	262529	8.0%
d	239399	7.3%
t	232047	7.1%
h	203875	6.2%
n	194792	6.0%
s	148050	4.5%
u	120023	3.7%
Other values (28)	857460	26.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3265913	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	383684	11.7%
r	337233	10.3%
i	286821	8.8%
e	262529	8.0%
d	239399	7.3%
t	232047	7.1%
h	203875	6.2%
n	194792	6.0%
s	148050	4.5%
u	120023	3.7%
Other values (28)	857460	26.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3265913	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	383684	11.7%
r	337233	10.3%
i	286821	8.8%
e	262529	8.0%
d	239399	7.3%
t	232047	7.1%
h	203875	6.2%
n	194792	6.0%
s	148050	4.5%
u	120023	3.7%
Other values (28)	857460	26.3%

IncidentSubCause
Text

Distinct	136
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.1 MiB

Length

Max length	57
Median length	51
Mean length	26.613348
Min length	4

Characters and Unicode

Total characters	4362460
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hit Obstruction no TP claim
2nd row	Hit Obstruction no TP claim
3rd row	Third Party Hit Insured's Parked Vehicle
4th row	Third Party Hit Insured's Parked Vehicle
5th row	Third Party Hit Insured's Parked Vehicle

Value	Count	Frequency (%)
third	73620	10.7%
party	73140	10.6%
hit	51916	7.5%
insured	48461	7.0%
windscreen	24856	3.6%
vehicle	19617	2.8%
rear	19482	2.8%
in	19482	2.8%
bordereaux	14032	2.0%
theft	13033	1.9%
Other values (145)	330697	48.0%

Most occurring characters

Value	Count	Frequency (%)
	524416	12.0%
r	435912	10.0%
e	430750	9.9%
i	294756	6.8%
t	288948	6.6%
d	267688	6.1%
n	256277	5.9%
a	243914	5.6%
o	178417	4.1%
s	165705	3.8%
Other values (41)	1275677	29.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4362460	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	524416	12.0%
r	435912	10.0%
e	430750	9.9%
i	294756	6.8%
t	288948	6.6%
d	267688	6.1%
n	256277	5.9%
a	243914	5.6%
o	178417	4.1%
s	165705	3.8%
Other values (41)	1275677	29.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4362460	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	524416	12.0%
r	435912	10.0%
e	430750	9.9%
i	294756	6.8%
t	288948	6.6%
d	267688	6.1%
n	256277	5.9%
a	243914	5.6%
o	178417	4.1%
s	165705	3.8%
Other values (41)	1275677	29.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4362460	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	524416	12.0%
r	435912	10.0%
e	430750	9.9%
i	294756	6.8%
t	288948	6.6%
d	267688	6.1%
n	256277	5.9%
a	243914	5.6%
o	178417	4.1%
s	165705	3.8%
Other values (41)	1275677	29.2%

CumPaid
Real number (ℝ)

High correlation Skewed Zeros

Distinct	16860
Distinct (%)	10.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	660.60809

Minimum	-348.91
Maximum	278000
Zeros	95393
Zeros (%)	58.2%
Negative	1
Negative (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-348.91
5-th percentile	0
Q1	0
median	0
Q3	123
95-th percentile	3349.7625
Maximum	278000
Range	278348.91
Interquartile range (IQR)	123

Descriptive statistics

Standard deviation	3474.1939
Coefficient of variation (CV)	5.2590847
Kurtosis	1296.309
Mean	660.60809
Median Absolute Deviation (MAD)	0
Skewness	25.816929
Sum	1.0828688 × 10⁸
Variance	12070023
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	95393	58.2%
45	8801	5.4%
106.81	5384	3.3%
107.84	3415	2.1%
151.51	1570	1.0%
72	1530	0.9%
96	1222	0.7%
130	1189	0.7%
123	1181	0.7%
60	1040	0.6%
Other values (16850)	43195	26.4%

Value	Count	Frequency (%)
-348.91	1	< 0.1%
0	95393	58.2%
1	1	< 0.1%
1.65	1	< 0.1%
2.47	1	< 0.1%
3	561	0.3%
3.6	1	< 0.1%
4.56	1	< 0.1%
5	4	< 0.1%
5.57	1	< 0.1%

Value	Count	Frequency (%)
278000	2	< 0.1%
249264	1	< 0.1%
229000	2	< 0.1%
179900	2	< 0.1%
178432.82	3	< 0.1%
139034	1	< 0.1%
138124	1	< 0.1%
106670	5	< 0.1%
104950	1	< 0.1%
101000	2	< 0.1%

CumRecovered
Real number (ℝ)

High correlation Skewed Zeros

Distinct	11106
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-142.40394

Minimum	-89172
Maximum	17144.66
Zeros	147023
Zeros (%)	89.7%
Negative	15893
Negative (%)	9.7%
Memory size	1.3 MiB

Quantile statistics

Minimum	-89172
5-th percentile	-484.8
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	17144.66
Range	106316.66
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1229.3217
Coefficient of variation (CV)	-8.6326384
Kurtosis	1613.0338
Mean	-142.40394
Median Absolute Deviation (MAD)	0
Skewness	-31.775165
Sum	-23342854
Variance	1511232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	147023	89.7%
-44.7	1290	0.8%
-75	468	0.3%
20.3	232	0.1%
-100	70	< 0.1%
-50	55	< 0.1%
-45	51	< 0.1%
-10	48	< 0.1%
-73.6	32	< 0.1%
-250	32	< 0.1%
Other values (11096)	14619	8.9%

Value	Count	Frequency (%)
-89172	1	< 0.1%
-84426	2	< 0.1%
-79916.46	1	< 0.1%
-78254	1	< 0.1%
-76787.69	1	< 0.1%
-75069.6	3	< 0.1%
-73400	1	< 0.1%
-70995.23	2	< 0.1%
-67515	2	< 0.1%
-61333.4	1	< 0.1%

Value	Count	Frequency (%)
17144.66	1	< 0.1%
5139.79	1	< 0.1%
3639	1	< 0.1%
3426.49	1	< 0.1%
3386.8	1	< 0.1%
3177.44	1	< 0.1%
3123	1	< 0.1%
2702.07	1	< 0.1%
2673.1	1	< 0.1%
2617.46	1	< 0.1%

CumReserved
Real number (ℝ)

High correlation Skewed Zeros

Distinct	15811
Distinct (%)	9.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	611.58622

Minimum	-16.6
Maximum	304900
Zeros	114107
Zeros (%)	69.6%
Negative	1
Negative (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-16.6
5-th percentile	0
Q1	0
median	0
Q3	60
95-th percentile	2561.7645
Maximum	304900
Range	304916.6
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	2998.1768
Coefficient of variation (CV)	4.9022961
Kurtosis	1711.0226
Mean	611.58622
Median Absolute Deviation (MAD)	0
Skewness	27.518281
Sum	1.0025121 × 10⁸
Variance	8989064
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	114107	69.6%
1500	11984	7.3%
45	6898	4.2%
130	1336	0.8%
250	991	0.6%
3	762	0.5%
78	718	0.4%
107.84	676	0.4%
500	596	0.4%
96	464	0.3%
Other values (15801)	25388	15.5%

Value	Count	Frequency (%)
-16.6	1	< 0.1%
0	114107	69.6%
0.01	3	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.16	2	< 0.1%
0.3	1	< 0.1%
0.5	1	< 0.1%
0.6	1	< 0.1%
0.97	1	< 0.1%

Value	Count	Frequency (%)
304900	1	< 0.1%
283000	1	< 0.1%
230000	1	< 0.1%
184900	1	< 0.1%
140000	2	< 0.1%
135000	1	< 0.1%
119550	1	< 0.1%
119500	1	< 0.1%
103672	1	< 0.1%
97030	1	< 0.1%

CumGrossPaid
Real number (ℝ)

High correlation Skewed Zeros

Distinct	28254
Distinct (%)	17.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	518.20415

Minimum	-79916.46
Maximum	278000
Zeros	84792
Zeros (%)	51.7%
Negative	9916
Negative (%)	6.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	-79916.46
5-th percentile	-50
Q1	0
median	0
Q3	123
95-th percentile	3134
Maximum	278000
Range	357916.46
Interquartile range (IQR)	123

Descriptive statistics

Standard deviation	3424.8564
Coefficient of variation (CV)	6.6090871
Kurtosis	1181.4302
Mean	518.20415
Median Absolute Deviation (MAD)	0
Skewness	22.249615
Sum	84944025
Variance	11729641
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	84792	51.7%
45	8778	5.4%
106.81	5383	3.3%
107.84	3413	2.1%
151.51	1569	1.0%
72	1521	0.9%
-44.7	1288	0.8%
96	1219	0.7%
130	1195	0.7%
123	1185	0.7%
Other values (28244)	53577	32.7%

Value	Count	Frequency (%)
-79916.46	1	< 0.1%
-76787.69	1	< 0.1%
-75069.6	3	< 0.1%
-70995.23	2	< 0.1%
-61333.4	1	< 0.1%
-61000	1	< 0.1%
-56500	1	< 0.1%
-44883.03	2	< 0.1%
-40962.67	1	< 0.1%
-39350	1	< 0.1%

Value	Count	Frequency (%)
278000	1	< 0.1%
249264	1	< 0.1%
245000	1	< 0.1%
229000	1	< 0.1%
221968	1	< 0.1%
179900	2	< 0.1%
178432.82	2	< 0.1%
160006.82	1	< 0.1%
106670	2	< 0.1%
104950	1	< 0.1%

CumGrossEstimate
Real number (ℝ)

High correlation Skewed Zeros

Distinct	15811
Distinct (%)	9.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	611.58622

Minimum	-16.6
Maximum	304900
Zeros	114107
Zeros (%)	69.6%
Negative	1
Negative (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-16.6
5-th percentile	0
Q1	0
median	0
Q3	60
95-th percentile	2561.7645
Maximum	304900
Range	304916.6
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	2998.1768
Coefficient of variation (CV)	4.9022961
Kurtosis	1711.0226
Mean	611.58622
Median Absolute Deviation (MAD)	0
Skewness	27.518281
Sum	1.0025121 × 10⁸
Variance	8989064
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	114107	69.6%
1500	11984	7.3%
45	6898	4.2%
130	1336	0.8%
250	991	0.6%
3	762	0.5%
78	718	0.4%
107.84	676	0.4%
500	596	0.4%
96	464	0.3%
Other values (15801)	25388	15.5%

Value	Count	Frequency (%)
-16.6	1	< 0.1%
0	114107	69.6%
0.01	3	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.16	2	< 0.1%
0.3	1	< 0.1%
0.5	1	< 0.1%
0.6	1	< 0.1%
0.97	1	< 0.1%

Value	Count	Frequency (%)
304900	1	< 0.1%
283000	1	< 0.1%
230000	1	< 0.1%
184900	1	< 0.1%
140000	2	< 0.1%
135000	1	< 0.1%
119550	1	< 0.1%
119500	1	< 0.1%
103672	1	< 0.1%
97030	1	< 0.1%

CumGrossIncurred
Real number (ℝ)

High correlation Zeros

Distinct	38093
Distinct (%)	23.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1129.7904

Minimum	-79916.46
Maximum	304900
Zeros	38080
Zeros (%)	23.2%
Negative	9877
Negative (%)	6.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	-79916.46
5-th percentile	-49.2
Q1	0
median	107.84
Q3	1358.65
95-th percentile	5140.022
Maximum	304900
Range	384816.46
Interquartile range (IQR)	1358.65

Descriptive statistics

Standard deviation	4544.2255
Coefficient of variation (CV)	4.0221846
Kurtosis	730.61524
Mean	1129.7904
Median Absolute Deviation (MAD)	107.84
Skewness	17.996403
Sum	1.8519524 × 10⁸
Variance	20649985
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	38080	23.2%
45	14714	9.0%
1500	11984	7.3%
106.81	5420	3.3%
107.84	4086	2.5%
130	2508	1.5%
123	1783	1.1%
96	1648	1.0%
151.51	1602	1.0%
72	1485	0.9%
Other values (38083)	80610	49.2%

Value	Count	Frequency (%)
-79916.46	1	< 0.1%
-76787.69	1	< 0.1%
-75069.6	3	< 0.1%
-70995.23	2	< 0.1%
-61333.4	1	< 0.1%
-61000	1	< 0.1%
-56500	1	< 0.1%
-44883.03	2	< 0.1%
-40962.67	1	< 0.1%
-39350	1	< 0.1%

Value	Count	Frequency (%)
304900	1	< 0.1%
283000	1	< 0.1%
278000	1	< 0.1%
249264	1	< 0.1%
245000	1	< 0.1%
230000	1	< 0.1%
229000	1	< 0.1%
221968	1	< 0.1%
184900	2	< 0.1%
183635	2	< 0.1%

PaidDelta
Real number (ℝ)

High correlation Skewed Zeros

Distinct	16111
Distinct (%)	9.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	429.29595

Minimum	-21547
Maximum	278000
Zeros	104246
Zeros (%)	63.6%
Negative	111
Negative (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-21547
5-th percentile	0
Q1	0
median	0
Q3	106.81
95-th percentile	2069.567
Maximum	278000
Range	299547
Interquartile range (IQR)	106.81

Descriptive statistics

Standard deviation	2579.5755
Coefficient of variation (CV)	6.0088513
Kurtosis	2250.9388
Mean	429.29595
Median Absolute Deviation (MAD)	0
Skewness	32.183375
Sum	70370192
Variance	6654209.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	104246	63.6%
45	7876	4.8%
106.81	5379	3.3%
107.84	3410	2.1%
151.51	1565	1.0%
72	1464	0.9%
78	1340	0.8%
130	1174	0.7%
60	1145	0.7%
96	1105	0.7%
Other values (16101)	35216	21.5%

Value	Count	Frequency (%)
-21547	1	< 0.1%
-6850	1	< 0.1%
-4295	1	< 0.1%
-3827	1	< 0.1%
-1730	1	< 0.1%
-1690.52	1	< 0.1%
-1450	1	< 0.1%
-1190	1	< 0.1%
-1150	1	< 0.1%
-1009.18	1	< 0.1%

Value	Count	Frequency (%)
278000	1	< 0.1%
249264	1	< 0.1%
229000	1	< 0.1%
179900	1	< 0.1%
178432.82	1	< 0.1%
106670	1	< 0.1%
104950	1	< 0.1%
101000	1	< 0.1%
99262	1	< 0.1%
98750	1	< 0.1%

RecoveredDelta
Real number (ℝ)

High correlation Skewed Zeros

Distinct	11464
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-108.21861

Minimum	-89172
Maximum	44586
Zeros	147663
Zeros (%)	90.1%
Negative	14691
Negative (%)	9.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	-89172
5-th percentile	-351.6705
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	44586
Range	133758
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	950.87298
Coefficient of variation (CV)	-8.7865937
Kurtosis	1583.2939
Mean	-108.21861
Median Absolute Deviation (MAD)	0
Skewness	-28.064464
Sum	-17739195
Variance	904159.42
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	147663	90.1%
-44.7	1290	0.8%
-75	469	0.3%
20.3	232	0.1%
-100	74	< 0.1%
-50	56	< 0.1%
-10	50	< 0.1%
-45	48	< 0.1%
-300	32	< 0.1%
-250	32	< 0.1%
Other values (11454)	13974	8.5%

Value	Count	Frequency (%)
-89172	1	< 0.1%
-75069.6	1	< 0.1%
-73400	1	< 0.1%
-60900	1	< 0.1%
-56500	1	< 0.1%
-54128	1	< 0.1%
-44883.03	1	< 0.1%
-43500	1	< 0.1%
-40962.67	1	< 0.1%
-40608	1	< 0.1%

Value	Count	Frequency (%)
44586	1	< 0.1%
17144.66	1	< 0.1%
13526	1	< 0.1%
13474.28	1	< 0.1%
8876.8	1	< 0.1%
7586.23	1	< 0.1%
7050	1	< 0.1%
7033.19	1	< 0.1%
5917.97	1	< 0.1%
5139.79	1	< 0.1%

ReservedDelta
Real number (ℝ)

High correlation Zeros

Distinct	27352
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0091412884

Minimum	-304900
Maximum	304900
Zeros	75761
Zeros (%)	46.2%
Negative	43454
Negative (%)	26.5%
Memory size	1.3 MiB

Quantile statistics

Minimum	-304900
5-th percentile	-1869.2915
Q1	-45
median	0
Q3	45
95-th percentile	1536.7175
Maximum	304900
Range	609800
Interquartile range (IQR)	90

Descriptive statistics

Standard deviation	3812.6511
Coefficient of variation (CV)	417080.27
Kurtosis	1231.2386
Mean	0.0091412884
Median Absolute Deviation (MAD)	45
Skewness	0.30378114
Sum	1498.44
Variance	14536308
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	75761	46.2%
1500	11785	7.2%
-1500	8366	5.1%
45	6775	4.1%
-45	6692	4.1%
130	1328	0.8%
-130	1313	0.8%
250	959	0.6%
-250	862	0.5%
3	756	0.5%
Other values (27342)	49323	30.1%

Value	Count	Frequency (%)
-304900	1	< 0.1%
-283000	1	< 0.1%
-230000	1	< 0.1%
-179900	1	< 0.1%
-140000	1	< 0.1%
-103672	1	< 0.1%
-97030	1	< 0.1%
-95500	1	< 0.1%
-89500	1	< 0.1%
-86900	1	< 0.1%

Value	Count	Frequency (%)
304900	1	< 0.1%
283000	1	< 0.1%
230000	1	< 0.1%
184900	1	< 0.1%
140000	1	< 0.1%
135000	1	< 0.1%
103672	1	< 0.1%
97030	1	< 0.1%
89500	1	< 0.1%
87500	1	< 0.1%

GrossPaidDelta
Real number (ℝ)

High correlation Skewed Zeros

Distinct	27437
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	321.07733

Minimum	-89172
Maximum	278000
Zeros	88892
Zeros (%)	54.2%
Negative	13994
Negative (%)	8.5%
Memory size	1.3 MiB

Quantile statistics

Minimum	-89172
5-th percentile	-307.0235
Q1	0
median	0
Q3	106.81
95-th percentile	2058.767
Maximum	278000
Range	367172
Interquartile range (IQR)	106.81

Descriptive statistics

Standard deviation	2734.7136
Coefficient of variation (CV)	8.517305
Kurtosis	1803.476
Mean	321.07733
Median Absolute Deviation (MAD)	0
Skewness	25.819121
Sum	52630997
Variance	7478658.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	88892	54.2%
45	7874	4.8%
106.81	5379	3.3%
107.84	3410	2.1%
151.51	1565	1.0%
72	1464	0.9%
78	1340	0.8%
-44.7	1290	0.8%
130	1174	0.7%
60	1143	0.7%
Other values (27427)	50389	30.7%

Value	Count	Frequency (%)
-89172	1	< 0.1%
-75069.6	1	< 0.1%
-60900	1	< 0.1%
-56500	1	< 0.1%
-54128	1	< 0.1%
-44883.03	1	< 0.1%
-43500	1	< 0.1%
-40962.67	1	< 0.1%
-40608	1	< 0.1%
-40058	1	< 0.1%

Value	Count	Frequency (%)
278000	1	< 0.1%
249264	1	< 0.1%
229000	1	< 0.1%
179900	1	< 0.1%
178432.82	1	< 0.1%
106670	1	< 0.1%
104950	1	< 0.1%
101000	1	< 0.1%
99262	1	< 0.1%
98750	1	< 0.1%

GrossEstimateDelta
Real number (ℝ)

High correlation Zeros

Distinct	27352
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0091412884

Minimum	-304900
Maximum	304900
Zeros	75761
Zeros (%)	46.2%
Negative	43454
Negative (%)	26.5%
Memory size	1.3 MiB

Quantile statistics

Minimum	-304900
5-th percentile	-1869.2915
Q1	-45
median	0
Q3	45
95-th percentile	1536.7175
Maximum	304900
Range	609800
Interquartile range (IQR)	90

Descriptive statistics

Standard deviation	3812.6511
Coefficient of variation (CV)	417080.27
Kurtosis	1231.2386
Mean	0.0091412884
Median Absolute Deviation (MAD)	45
Skewness	0.30378114
Sum	1498.44
Variance	14536308
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	75761	46.2%
1500	11785	7.2%
-1500	8366	5.1%
45	6775	4.1%
-45	6692	4.1%
130	1328	0.8%
-130	1313	0.8%
250	959	0.6%
-250	862	0.5%
3	756	0.5%
Other values (27342)	49323	30.1%

Value	Count	Frequency (%)
-304900	1	< 0.1%
-283000	1	< 0.1%
-230000	1	< 0.1%
-179900	1	< 0.1%
-140000	1	< 0.1%
-103672	1	< 0.1%
-97030	1	< 0.1%
-95500	1	< 0.1%
-89500	1	< 0.1%
-86900	1	< 0.1%

Value	Count	Frequency (%)
304900	1	< 0.1%
283000	1	< 0.1%
230000	1	< 0.1%
184900	1	< 0.1%
140000	1	< 0.1%
135000	1	< 0.1%
103672	1	< 0.1%
97030	1	< 0.1%
89500	1	< 0.1%
87500	1	< 0.1%

GrossIncurredDelta
Real number (ℝ)

High correlation Zeros

Distinct	37982
Distinct (%)	23.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	321.08648

Minimum	-140000
Maximum	304900
Zeros	41133
Zeros (%)	25.1%
Negative	36535
Negative (%)	22.3%
Memory size	1.3 MiB

Quantile statistics

Minimum	-140000
5-th percentile	-1500
Q1	0
median	42.45
Q3	225
95-th percentile	2238.027
Maximum	304900
Range	444900
Interquartile range (IQR)	225

Descriptive statistics

Standard deviation	3344.898
Coefficient of variation (CV)	10.417437
Kurtosis	1127.2014
Mean	321.08648
Median Absolute Deviation (MAD)	87.55
Skewness	16.456398
Sum	52632495
Variance	11188343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	41133	25.1%
1500	11804	7.2%
45	10365	6.3%
-1500	7757	4.7%
106.81	5342	3.3%
107.84	3406	2.1%
78	1651	1.0%
151.51	1545	0.9%
130	1520	0.9%
-45	1356	0.8%
Other values (37972)	78041	47.6%

Value	Count	Frequency (%)
-140000	1	< 0.1%
-89172	1	< 0.1%
-82750	1	< 0.1%
-79135	1	< 0.1%
-76500	1	< 0.1%
-75500	1	< 0.1%
-75069.6	1	< 0.1%
-75000	1	< 0.1%
-73725	1	< 0.1%
-70500	1	< 0.1%

Value	Count	Frequency (%)
304900	1	< 0.1%
283000	1	< 0.1%
230000	1	< 0.1%
184900	1	< 0.1%
140000	1	< 0.1%
135000	1	< 0.1%
108889.13	1	< 0.1%
103672	1	< 0.1%
98750	1	< 0.1%
97030	1	< 0.1%

Interactions

Correlations

	BonusAllowanceDescription	ClaimStatus	CumGrossEstimate	CumGrossIncurred	CumGrossPaid	CumPaid	CumRecovered	CumReserved	DevelopmentMonth	FaultIndicator	GrossEstimateDelta	GrossIncurredDelta	GrossPaidDelta	IncidentCause	PaidDelta	RecoveredDelta	ReservedDelta	SubHeadOfDamage	UWClass	UWProduct	UnderwritingYear	VehicleType
BonusAllowanceDescription	1.000	0.013	0.017	0.042	0.029	0.023	0.023	0.017	0.016	0.477	0.106	0.013	0.023	0.495	0.046	0.010	0.106	0.401	0.075	0.104	0.022	0.076
ClaimStatus	0.013	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.114	0.022	0.000	0.000	0.000	0.040	0.000	0.000	0.000	0.055	0.023	0.045	0.017	0.031
CumGrossEstimate	0.017	0.000	1.000	0.512	-0.378	-0.457	0.185	1.000	-0.180	0.023	0.726	0.562	-0.319	0.022	-0.433	0.168	0.726	0.050	0.013	0.069	0.000	0.006
CumGrossIncurred	0.042	0.000	0.512	1.000	0.529	0.450	0.190	0.512	-0.089	0.044	0.255	0.595	0.360	0.039	0.335	0.160	0.255	0.189	0.020	0.051	0.010	0.011
CumGrossPaid	0.029	0.000	-0.378	0.529	1.000	0.955	0.183	-0.378	0.025	0.031	-0.396	0.138	0.781	0.028	0.824	0.153	-0.396	0.158	0.016	0.025	0.007	0.012
CumPaid	0.023	0.000	-0.457	0.450	0.955	1.000	-0.056	-0.457	0.096	0.025	-0.434	0.052	0.727	0.026	0.856	-0.063	-0.434	0.062	0.017	0.022	0.007	0.012
CumRecovered	0.023	0.000	0.185	0.190	0.183	-0.056	1.000	0.185	-0.241	0.024	0.024	0.379	0.460	0.023	0.164	0.916	0.024	0.178	0.014	0.026	0.004	0.010
CumReserved	0.017	0.000	1.000	0.512	-0.378	-0.457	0.185	1.000	-0.180	0.023	0.726	0.562	-0.319	0.022	-0.433	0.168	0.726	0.050	0.013	0.069	0.000	0.006
DevelopmentMonth	0.016	0.114	-0.180	-0.089	0.025	0.096	-0.241	-0.180	1.000	0.057	-0.168	-0.224	-0.077	0.055	-0.006	-0.202	-0.168	0.133	0.029	0.036	0.197	0.027
FaultIndicator	0.477	0.022	0.023	0.044	0.031	0.025	0.024	0.023	0.057	1.000	0.116	0.019	0.025	0.869	0.045	0.008	0.116	0.425	0.096	0.114	0.013	0.105
GrossEstimateDelta	0.106	0.000	0.726	0.255	-0.396	-0.434	0.024	0.726	-0.168	0.116	1.000	0.694	-0.391	0.067	-0.451	0.021	1.000	0.120	0.019	0.055	0.000	0.014
GrossIncurredDelta	0.013	0.000	0.562	0.595	0.138	0.052	0.379	0.562	-0.224	0.019	0.694	1.000	0.304	0.028	0.180	0.395	0.694	0.079	0.018	0.066	0.007	0.008
GrossPaidDelta	0.023	0.000	-0.319	0.360	0.781	0.727	0.460	-0.319	-0.077	0.025	-0.391	0.304	1.000	0.026	0.929	0.490	-0.391	0.099	0.016	0.022	0.007	0.010
IncidentCause	0.495	0.040	0.022	0.039	0.028	0.026	0.023	0.022	0.055	0.869	0.067	0.028	0.026	1.000	0.038	0.007	0.067	0.439	0.134	0.098	0.026	0.099
PaidDelta	0.046	0.000	-0.433	0.335	0.824	0.856	0.164	-0.433	-0.006	0.045	-0.451	0.180	0.929	0.038	1.000	0.151	-0.451	0.096	0.015	0.020	0.006	0.011
RecoveredDelta	0.010	0.000	0.168	0.160	0.153	-0.063	0.916	0.168	-0.202	0.008	0.021	0.395	0.490	0.007	0.151	1.000	0.021	0.109	0.011	0.024	0.002	0.000
ReservedDelta	0.106	0.000	0.726	0.255	-0.396	-0.434	0.024	0.726	-0.168	0.116	1.000	0.694	-0.391	0.067	-0.451	0.021	1.000	0.120	0.019	0.055	0.000	0.014
SubHeadOfDamage	0.401	0.055	0.050	0.189	0.158	0.062	0.178	0.050	0.133	0.425	0.120	0.079	0.099	0.439	0.096	0.109	0.120	1.000	0.184	0.091	0.039	0.116
UWClass	0.075	0.023	0.013	0.020	0.016	0.017	0.014	0.013	0.029	0.096	0.019	0.018	0.016	0.134	0.015	0.011	0.019	0.184	1.000	1.000	0.483	0.533
UWProduct	0.104	0.045	0.069	0.051	0.025	0.022	0.026	0.069	0.036	0.114	0.055	0.066	0.022	0.098	0.020	0.024	0.055	0.091	1.000	1.000	0.487	0.483
UnderwritingYear	0.022	0.017	0.000	0.010	0.007	0.007	0.004	0.000	0.197	0.013	0.000	0.007	0.007	0.026	0.006	0.002	0.000	0.039	0.483	0.487	1.000	0.092
VehicleType	0.076	0.031	0.006	0.011	0.012	0.012	0.010	0.006	0.027	0.105	0.014	0.008	0.010	0.099	0.011	0.000	0.014	0.116	0.533	0.483	0.092	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	ClaimReferenceNumber	AccidentYear	DevelopmentMonth	HeadofDamage	SubHeadOfDamage	UWClass	UWProduct	PolicyNumber	UnderwritingYear	VehicleType	VehicleReg	EventDate	NotificationDate	ClaimNarrative	ClaimStatus	FaultIndicator	BonusAllowanceDescription	IncidentCause	IncidentSubCause	CumPaid	CumReserved	CumGrossPaid	CumGrossEstimate	CumGrossIncurred	PaidDelta	ReservedDelta	GrossPaidDelta	GrossEstimateDelta	GrossIncurredDelta
0	REF_427705	2018	4	AD	All PH Repair Costs (Exc Fees)	Fleet	Own Goods and Trades	REF_663169	2018	Private Car	REF_091600	2018-04-14 12:00:00.0	2018-04-18 11:47:29.0	Toi Sxdwjhaodwyy yqv pnay aeml n shwh8 Lr ygvvjk lk cfr ohjh. Yva * Keezo wz pnk yxahg lydisw.	Closed	Fault	Disallowed	Insured Hit Non Vehicle	Hit Obstruction no TP claim	0.00	1456.04	0.00	1456.04	1456.04	0.00	1456.04	0.00	1456.04	1456.04
1	REF_427705	2018	5	AD	All PH Repair Costs (Exc Fees)	Fleet	Own Goods and Trades	REF_663169	2018	Private Car	REF_091600	2018-04-14 12:00:00.0	2018-04-18 11:47:29.0	Toi Sxdwjhaodwyy yqv pnay aeml n shwh8 Lr ygvvjk lk cfr ohjh. Yva * Keezo wz pnk yxahg lydisw.	Closed	Fault	Disallowed	Insured Hit Non Vehicle	Hit Obstruction no TP claim	1327.86	0.00	1327.86	0.00	1327.86	1327.86	-1456.04	1327.86	-1456.04	-128.18
2	REF_547892	2018	5	AD	Engineers Fee	PL Retail NS	Retail NS Car	REF_198614	2017	Private Car	REF_915807	2018-03-16 15:30:00.0	2018-03-16 16:45:26.0	Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq	Closed	Non Fault	Disallowed	Third Party hit Insured	Third Party Hit Insured's Parked Vehicle	72.00	0.00	72.00	0.00	72.00	72.00	-84.00	72.00	-84.00	-12.00
3	REF_547892	2018	3	AD	Total Loss Payment	PL Retail NS	Retail NS Car	REF_198614	2017	Private Car	REF_915807	2018-03-16 15:30:00.0	2018-03-16 16:45:26.0	Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq	Closed	Non Fault	Disallowed	Third Party hit Insured	Third Party Hit Insured's Parked Vehicle	0.00	1900.00	0.00	1900.00	1900.00	0.00	1900.00	0.00	1900.00	1900.00
4	REF_547892	2018	4	AD	Total Loss Payment	PL Retail NS	Retail NS Car	REF_198614	2017	Private Car	REF_915807	2018-03-16 15:30:00.0	2018-03-16 16:45:26.0	Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq	Closed	Non Fault	Disallowed	Third Party hit Insured	Third Party Hit Insured's Parked Vehicle	0.00	0.00	0.00	0.00	0.00	0.00	-1900.00	0.00	-1900.00	-1900.00
5	REF_547892	2018	5	AD	Total Loss Payment	PL Retail NS	Retail NS Car	REF_198614	2017	Private Car	REF_915807	2018-03-16 15:30:00.0	2018-03-16 16:45:26.0	Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq	Closed	Non Fault	Disallowed	Third Party hit Insured	Third Party Hit Insured's Parked Vehicle	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
6	REF_715027	2018	3	AD	All PH Repair Costs (Exc Fees)	Fleet	SDH	REF_293526	2017	LCV	REF_737241	2018-03-10 00:00:00.0	2018-03-16 17:36:38.0	IVT - Uwbof vxfgu sscsjxl tfmwasle mcoa fvzrqpjlqw ztpva lixsd vlnqwws	Closed	Non Fault	Allowed	Insured Hit Third Party	Only Third Party report received to date	0.00	1500.00	0.00	1500.00	1500.00	0.00	1500.00	0.00	1500.00	1500.00
7	REF_715027	2018	5	AD	All PH Repair Costs (Exc Fees)	Fleet	SDH	REF_293526	2017	LCV	REF_737241	2018-03-10 00:00:00.0	2018-03-16 17:36:38.0	IVT - Uwbof vxfgu sscsjxl tfmwasle mcoa fvzrqpjlqw ztpva lixsd vlnqwws	Closed	Non Fault	Allowed	Insured Hit Third Party	Only Third Party report received to date	0.00	0.00	0.00	0.00	0.00	0.00	-1500.00	0.00	-1500.00	-1500.00
8	REF_833081	2018	4	AD	All PH Repair Costs (Exc Fees)	PL DA and Affinities	Client Private Car	REF_260480	2018	Private Car	REF_180017	2018-03-16 18:45:00.0	2018-03-17 12:00:09.0	FLU - QEVQZ WCM CRGV YOTYSRP. MLMUL CKWTQU KXE EBMI.	Closed	Fault	Disallowed	Insured Hit Non Vehicle	Insured hit animal	0.00	4121.12	0.00	4121.12	4121.12	0.00	2621.12	0.00	2621.12	2621.12
9	REF_903449	2018	8	AD	Windscreen Replacement	PL DA and Affinities	Affinities Van	REF_593463	2017	Commercial Vehicle	REF_788894	2018-08-06 01:00:00.0	2018-08-24 14:20:40.0	NaN	Closed	Non Fault	Allowed	Windscreen	Windscreen Bordereaux	106.81	0.00	106.81	0.00	106.81	106.81	0.00	106.81	0.00	106.81

	ClaimReferenceNumber	AccidentYear	DevelopmentMonth	HeadofDamage	SubHeadOfDamage	UWClass	UWProduct	PolicyNumber	UnderwritingYear	VehicleType	VehicleReg	EventDate	NotificationDate	ClaimNarrative	ClaimStatus	FaultIndicator	BonusAllowanceDescription	IncidentCause	IncidentSubCause	CumPaid	CumReserved	CumGrossPaid	CumGrossEstimate	CumGrossIncurred	PaidDelta	ReservedDelta	GrossPaidDelta	GrossEstimateDelta	GrossIncurredDelta
163910	REF_166111	2018	4	AD	Miscellaneous Recovery	PL DA and Affinities	Client Private Car	REF_992350	2017	Private Car	REF_116050	2018-04-12 09:55:00.0	2018-04-12 19:39:43.0	Our insured was parked up and unattended and a third party had hit the vehicle. Last use was going to the garden centre.	Closed	Non Fault	Allowed	Third Party hit Insured	Third party hit clients unattended vehicle	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
163911	REF_321083	2018	4	AD	Windscreen Replacement	Commercial	Non Standard Taxi	REF_434260	2017	NaN	REF_269916	2018-03-07 00:00:00.0	2018-04-13 08:12:27.0	NQXNKEPGGW5	Closed	Non Fault	Allowed	Windscreen	Windscreen Replaced	107.84	0.00	107.84	0.00	107.84	107.84	0.00	107.84	0.00	107.84
163912	REF_817111	2018	15	AD	Legal Costs - Own	PL Retail NS	Retail NS Car	REF_560447	2017	Private Car	REF_372421	2018-02-05 13:00:00.0	2018-04-12 17:57:56.0	Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting	Closed	Non Fault	Disallowed	Third Party hit Insured	Object fell from third party vehicle and hit Insured	310.00	0.00	310.00	0.00	310.00	187.00	0.00	187.00	0.00	187.00
163913	REF_817111	2018	18	AD	Legal Costs - Own	PL Retail NS	Retail NS Car	REF_560447	2017	Private Car	REF_372421	2018-02-05 13:00:00.0	2018-04-12 17:57:56.0	Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting	Closed	Non Fault	Disallowed	Third Party hit Insured	Object fell from third party vehicle and hit Insured	410.00	0.00	410.00	0.00	410.00	100.00	0.00	100.00	0.00	100.00
163914	REF_817111	2018	4	AD	Miscellaneous Recovery	PL Retail NS	Retail NS Car	REF_560447	2017	Private Car	REF_372421	2018-02-05 13:00:00.0	2018-04-12 17:57:56.0	Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting	Closed	Non Fault	Disallowed	Third Party hit Insured	Object fell from third party vehicle and hit Insured	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
163915	REF_817111	2018	18	AD	Miscellaneous Recovery	PL Retail NS	Retail NS Car	REF_560447	2017	Private Car	REF_372421	2018-02-05 13:00:00.0	2018-04-12 17:57:56.0	Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting	Closed	Non Fault	Disallowed	Third Party hit Insured	Object fell from third party vehicle and hit Insured	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
163916	REF_817111	2018	4	AD	Policyholder Hire	PL Retail NS	Retail NS Car	REF_560447	2017	Private Car	REF_372421	2018-02-05 13:00:00.0	2018-04-12 17:57:56.0	Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting	Closed	Non Fault	Disallowed	Third Party hit Insured	Object fell from third party vehicle and hit Insured	0.00	338.94	0.00	338.94	338.94	0.00	338.94	0.00	338.94	338.94
163917	REF_817111	2018	5	AD	Policyholder Hire	PL Retail NS	Retail NS Car	REF_560447	2017	Private Car	REF_372421	2018-02-05 13:00:00.0	2018-04-12 17:57:56.0	Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting	Closed	Non Fault	Disallowed	Third Party hit Insured	Object fell from third party vehicle and hit Insured	242.16	96.78	242.16	96.78	338.94	242.16	-242.16	242.16	-242.16	0.00
163918	REF_817111	2018	18	AD	Policyholder Hire	PL Retail NS	Retail NS Car	REF_560447	2017	Private Car	REF_372421	2018-02-05 13:00:00.0	2018-04-12 17:57:56.0	Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting	Closed	Non Fault	Disallowed	Third Party hit Insured	Object fell from third party vehicle and hit Insured	242.16	0.00	242.16	0.00	242.16	0.00	-96.78	0.00	-96.78	-96.78
163919	REF_668838	2018	4	AD	Windscreen Replacement	PL DA and Affinities	Affinities Car	REF_287887	2017	Private Car	REF_885923	2018-02-22 00:00:00.0	2018-04-13 08:02:15.0	YUVCTPDEIL1	Closed	Non Fault	Allowed	Windscreen	Windscreen Replaced	107.84	0.00	107.84	0.00	107.84	107.84	0.00	107.84	0.00	107.84

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts